namespace Forging2.DataBase.ZH_IMES
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    public partial class ly_employee
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public int GID { get; set; }

        [Required]
        [StringLength(50)]
        public string CODE { get; set; }

        [Required]
        [StringLength(100)]
        public string NAME { get; set; }

        [StringLength(32)]
        public string EMPLOYEE_CLASS_GID { get; set; }

        [StringLength(100)]
        public string USED_NAME { get; set; }

        [StringLength(32)]
        public string DEPT_GID { get; set; }

        [StringLength(32)]
        public string COMPANY_GID { get; set; }

        [StringLength(32)]
        public string OPERATOR_GID { get; set; }

        public int SEX { get; set; }

        [StringLength(50)]
        public string ID_CARD_NUM { get; set; }

        [StringLength(50)]
        public string SOC_CARD_NUM { get; set; }

        [Column(TypeName = "date")]
        public DateTime? BIRTHDAY { get; set; }

        [StringLength(256)]
        public string ADDRESS { get; set; }

        [StringLength(50)]
        public string ZIPCODE { get; set; }

        [StringLength(50)]
        public string OFFICE_TELE { get; set; }

        [StringLength(50)]
        public string HOME_TELE { get; set; }

        [StringLength(50)]
        public string MOBILE { get; set; }

        [StringLength(50)]
        public string EMAIL { get; set; }

        [Column(TypeName = "date")]
        public DateTime? CAREER_BEGIN_DATE { get; set; }

        [Column(TypeName = "date")]
        public DateTime? JOIN_COMPANY_DATE { get; set; }

        [StringLength(200)]
        public string REMARK { get; set; }

        [Required]
        [StringLength(32)]
        public string CREATE_ID { get; set; }

        [Column(TypeName = "datetime2")]
        public DateTime CREATE_DATE { get; set; }

        [Required]
        [StringLength(255)]
        public string SITE { get; set; }
    }
}
